"192.168.0.1:sipop" Previous topic Chapter index Next topic

TIPOUSUASIST

 

 

Descriptions

TIPO DE USUARIO DEL SISTEMA

 

Fields

PK

FK

Name

Domain

Data type

Not null

Default

Description

 

ID_TIPO_USUA_SIST

 

CHAR (3)

 

ID del tipo de usuario del sistema

 

 

NOMB_TIPO_USUA

 

CHAR (30)

 

Nombre del tipo de usuario

 

 

DESC_TIPO_USUA

 

CHAR (240)

 

 

Descripción del tipo de usuario

 

Triggers

There are no triggers for table TIPOUSUASIST

 

Indices

There are no indices for table TIPOUSUASIST

 

References

There are no references for table TIPOUSUASIST

 

Referenced

Table

Foreign Key

Fields

FK Fields

DEL Rule

UPD Rule

PERFILUSUASIST

FK_PERFILUSUASIST1

TIPO_USUA_SIST

ID_TIPO_USUA_SIST

RESTRICT

RESTRICT

 

Definition


CREATE TABLE TIPOUSUASIST (
    ID_TIPO_USUA_SIST CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMB_TIPO_USUA CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    DESC_TIPO_USUA CHAR (240) CHARACTER SET NONE COLLATE NONE);

ALTER TABLE TIPOUSUASIST ADD PRIMARY KEY (ID_TIPO_USUA_SIST);

    This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m. Previous topic Chapter index Next topic